package com.sky.mapper;

import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.sky.entity.Dish;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.sky.query.DishQuery;
import com.sky.vo.DishVO;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
* @author 马毅爽
* @description 针对表【dish(菜品)】的数据库操作Mapper
* @createDate 2023-11-03 09:41:33
* @Entity com.sky.entity.Dish
*/

public interface DishMapper extends BaseMapper<Dish> {

    Page<DishVO> queryPage(@Param("page") Page<DishVO> page, @Param("dishQuery") DishQuery dishQuery);

    @Select("select count(id) from dish where status = #{status}")
    Integer countByStatus(Integer status);
}




